﻿<?xml version="1.0" encoding="utf-8"?>
<AdoNetDataAccess connection="$AccountsDBConnection$" formatter="bizobjlist of Account(baseCurrencyType); match merged into productArticles">
	<Sql>
		SELECT
		ObjectTree.objectId AS id,
		[Currency].id AS baseCurrencyTypeid,
		[Currency].name AS baseCurrencyTypename,
		[Currency].description AS baseCurrencyTypedescription
		FROM
		(AccountCurrency
		INNER JOIN
		[Currency] ON AccountCurrency.currencyTypeId = [Currency].id)
		INNER JOIN
		ObjectTreeNodes ON AccountCurrency.objectTreeId = ObjectTreeNodes.id
		ORDER BY
		ObjectTreeNodes.objectId
	</Sql>
</AdoNetDataAccess>
